<link rel="stylesheet" type="text/css" href="styles/leiding.css" />
<center>
    <h2>De Leiding</h2>
    De leiding van de nieuwe Welpengroep zal zijn;<br />
    <br />
    <?php
    $ps = new PreparedStatement("SELECT * FROM accounts LEFT JOIN leiding ON accounts.accountid = leiding.accountid WHERE accounts.leiding = '1';");
    $q = $ps->execute();
    while($row = mysql_fetch_array($q))
    {
        echo "<div class='leiding'>";
            if(file_exists("images/uploads/leiding/{$row['accountid']}.jpg"))
            {
                echo "<img style='width: 200; height: 126;' class='leiding' src='images/uploads/leiding/{$row['accountid']}.jpg' alt='' />";
            }
            else
            {
            echo "<img class='leiding' src='images/leeg.gif' alt='' />";
            }
            echo "Naam:<br />";
            echo "Adres:<br />";
            echo "<br />";
            echo "Telefoon:<br />";
            echo "Mobiel:<br />";
            echo "E-mail:<br />";
            echo "Geboortedatum: ";
                echo "<div class='leidinginfo'>";
                    echo "{$row['naam']}<br />";
                    echo "{$row['adres']}<br />";
                    echo "{$row['postcode']} {$row['woonplaats']}<br />";
                    echo "{$row['telefoon']}<br />";
                    echo "{$row['mobiel']}<br />";
                    echo "{$row['e-mail']}<br />";
                    echo "{$row['geboortedatum']}<br />";
                echo "</div>";
        echo "</div>";
        
    }
    ?>
</center>